本篇讲下如何使用纯python代码将excel 中的图表导出为图片。这里需要使用的模块有win32com、pythoncom模块。
网上经查询有人已经写好的模块pyxlchart,具体代码如下:
from win32com.client import Dispatch
import os
import pythoncom
class Pyxlchart(object):
"""
This class exports charts in an Excel Spreadsheet to the FileSystem
win32com libraries are required.
"""
def __init__(self):
pythoncom.CoInitialize()
self.WorkbookDirectory = ""
self.WorkbookFilename = ""
self.GetAllWorkbooks = False
self.SheetName = ""
self.ChartName = ""
self.GetAllWorkbookCharts = False
self.GetAllWorksheetCharts = False
self.ExportPath = ""
self.ImageFilename = ""
self.ReplaceWhiteSpaceChar = "_"
self.ImageType = "jpg"
def __del__(self):
pass<